{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Introduction","SDGs","Instructions","Selection of indicators","Intervention 1 ","Intervention 1","MRV_Interv1","Monitoring sheet","Data Ranges (2)"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":2,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":81,"n_cols":9,"rows_kept":81,"cut":false,"hidden":false,"merged":[[9,1,9,9],[10,1,10,9],[16,1,16,12],[17,1,17,12],[18,1,18,13],[58,3,58,6],[53,1,53,3],[27,1,27,3],[11,1,11,11],[26,1,26,12],[53,4,53,7],[30,1,30,15],[47,2,47,7],[48,2,48,7],[51,1,51,3],[52,1,52,3],[51,4,51,7],[52,4,52,7],[49,2,49,7],[28,1,28,14]]}
[]
[null,null,null,null,"Sustainable Development Evaluation Tool [NAMA]"]
[null,null,"Date","2015-09-01"]
[null,null,"Version",1]
[null,"Empowered lives."]
[null,"Resilient nations"]
[]
[null,"Introduction"]
[]
[null,"This tool has been designed for NAMA developers and policy makers."]
[null,"This tool has been designed to evaluate the Sustainable Development performance indicators for NAMAs and to evaluate the Sustainable Development results achieved over the lifetime of the NAMA."]
[null,"The tool should allow policy makers to track and highlight the effects of a NAMA on environmental conservation, economic growth, poverty reduction and public welfare.  "]
[]
[]
[null,"Origin of 5 Domains and indicators"]
[null,"Domains"]
[null,"Different domains are identified for sustainable development.  International organizations broadly use the three famous pillars: environment, social and economic for classification of SD benefits. However, couple of indicators always have a dual effect on either of these pillars ( For example women empowerment will have effect both on social and economic domain), therefore, it becomes necessary to classify them into another pillar (pillar is being replaced by Domain in this tool) for easy and consistent reporting. The fourth domain was called \"Development and Growth\" This domain will be used to classify all the overlapping indicators. A fifth domain has been introduced which helps  measure the institutional aspect behind a NAMA. It would further help check the policy and laws governing the  NAMA. "]
[]
[null,"New break up of SD domains are as below:"]
[null,"Environment","This domain would only cater to changes in environment (pollution reduction or quality improvement) due to an intervention"]
[null,"Social","This domain would cater to social aspects of the intervention. Since the social impacts would also have an impact on economic benefits, this domain will only assess the social impacts, which are not linked to any other domains"]
[null,"Growth and Development","This domain will cater to the development aspects of the intervention without linking it to financial benefits."]
[null,"Economic","This domain would calculate the economic (money) related benefits which can be measured directly."]
[null,"Institutional ","This domain would check the policy and laws governing the NAMA"]
[]
[null,"Indicators"]
[null,"The tool proposes selecting indicators that reflect how the NAMA interventions support sustainable development. In order to limit the burden on human and financial resources to measure and report data, policy-makers should select a small, core list of indicators that are specific, meaningful, measurable, and cost-effective to collect. They should also be pertinent and easy to understand."]
[null,"At least one indicator per domain needs to be assessed by the NAMA implementer. "]
[null,"Indicators have been selected after a deep analysis of the existing NAMAs papers from the UNEP Risoe and Ecofys databases and also have been sorted according to their relevance to SDGs which are under development.  "]
[]
[null,"This tool has described the relevance of indicators to SDGs, however this may be subject to change as the SDGs are yet not finalized. SDGs are listed below."]
[]
[]
[null,"Contents of the tool /description of the tabs"]
[]
[null,"The tool consists of the following tabs:"]
[null,"Instructions","Instructions","Provides instructions for the user and guidance for monitoring"]
[null,"SDGs and Targets","SDGs and Targets","Lists the SDGs and relative targets"]
[null,"Selections of indicators","Selection of indicators","Provides a table for the selection of the indicators"]
[null,"SD Evaluation","NAIs","Provides a summary of the NAIs calculated"]
[null,null,"Intervention 1","Evaluates the SD benefits of the intervention 1 "]
[null,"Monitoring","MRV Intervention 1","Provides tables for the MRV procedures of intervention 1  "]
[null,null,"Monitoring sheet","Lists the monitoring parameters"]
[]
[]
[null,"NAMA's information"]
[]
[null,"Name","NAMA for the Renewable Energy Sector of Lao PDR"]
[null,"NAMA implementer"]
[null,"Country"," Lao PDR"]
[]
[null,"Intervention",null,null,"Short description of intervention",null,null,null,"Intervention implementers"]
[null,"Mini grid ",null,null,"New mini grids based on renewable energy will be installed in rural communities "]
[]
[]
[]
[null,"Determination of NAMA ambition and NAMA success with Nationally Appropriate Improvements (NAIs):"]
[null,"NAIs are calculated for each intervention, the mean value is determined for each domain, and the overall ambition and success of the NAMA calculated as the mean value over all domains. The applied formula are shown as follows:  "]
[null,null,"The more the better","The fewer the better",null,null,null,"Baseline = 0"]
[null,"NAIest ="]
[null,"NAIex-post ="]
[null,"Evaluation of Project ="]
[null,null,"Whereas:"]
[null,null,"Vbasic:","Baseline Value"]
[null,null,"Vest:","Estimated Target-Value"]
[null,null,"Vex-post:","Monitored Intervention-Value"]
[null,null,"NAIest:","Estimated NAI (ex ante)"]
[null,null,"NAIex-post:","Monitored NAI (ex-post)"]
[]
[]
[null,"Sustainable Development Goals (SDGs)"]
[null,"SDGs refer to an agreement of the United Nations Conference on Sustainable Development held in Rio in June 2012 (Rio+20), to develop a set of future international development goals."]
[null,"These goals constitute an integrated, indivisible set of global priorities for sustainable development. Targets are defined as aspirational global targets."]
[null,"This tool makes a link between the indicators chosen for each domain and the corresponding targets. The chosen parameters indicate the positive impact of the intervention to the related target."]
[null,"SDGs have been further elaborated in SDGs and Targets Tab:"]
[null,"SDGs and Targets"]
[]
[]
[null,"Acknowledgment"]
[null," SD tool: Sophie Tison, Tanushree Bagh,\n South Pole Carbon Asset Management Ltd","Addition of institutional domain: based on the SD Framework by UNEP DTU"]
[null,"Copyright 2014 United Nations Development Programme"]

{"sheet":"SDGs","index":1,"n_rows":179,"n_cols":3,"rows_kept":179,"cut":false,"hidden":false,"merged":[[30,1,39,1],[30,0,39,0],[3,0,9,0],[3,1,9,1],[0,0,0,2],[10,0,16,0],[10,1,16,1],[17,0,29,0],[17,1,29,1],[49,0,56,0],[49,1,56,1],[57,0,61,0],[57,1,61,1],[40,0,48,0],[40,1,48,1],[62,0,73,0],[62,1,73,1],[82,0,91,0],[82,1,91,1],[92,0,101,0],[92,1,101,1],[74,0,81,0],[74,1,81,1],[102,0,112,0],[102,1,112,1],[140,0,151,0],[140,1,151,1],[152,0,178,0],[152,1,178,1],[113,0,117,0],[113,1,117,1],[118,1,127,1],[118,0,127,0],[128,0,139,0],[128,1,139,1]]}
["SDGs and Targets"]
[]
["Goal    Number","Goal Aim","Goal Targets"]
["GOAL 1","End poverty in all its forms everywhere","1.1 by 2030, eradicate extreme poverty for all people everywhere, currently measured as people living on less than $1.25 a day"]
[null,null,"1.2 by 2030, reduce at least by half the proportion of men, women and children of all ages living in poverty in all its dimensions according to national definitions"]
[null,null,"1.3 implement nationally appropriate social protection systems and measures for all, including floors, and by 2030 achieve substantial coverage of the poor and the vulnerable"]
[null,null,"1.4 by 2030 ensure that all men and women, particularly the poor and the vulnerable, have equal rights to economic resources, as well as access to basic services, ownership, and control over land and other forms of property, inheritance, natural resources, appropriate new technology, and financial services including microfinance"]
[null,null,"1.5 by 2030 build the resilience of the poor and those in vulnerable situations, and reduce their exposure and vulnerability to climate-related extreme events and other economic, social and environmental shocks and disasters"]
[null,null,"1.a ensure significant mobilization of resources from a variety of sources, including through enhanced development cooperation to provide adequate and predictable means for developing countries, in particular LDCs, to implement programmes and policies to end poverty in all its dimensions"]
[null,null,"1.b create sound policy frameworks, at national, regional and international levels, based on pro-poor and gender-sensitive development strategies to support accelerated investments in poverty eradication actions"]
["GOAL 2","End Hunger, achieve food security and improved nutrition and promote sustainable agriculture","2.1 by 2030 end hunger and ensure access by all people, in particular the poor and people in vulnerable situations including infants, to safe, nutritious and sufficient food all year round"]
[null,null,"2.2 by 2030 end all forms of malnutrition, including achieving by 2025 the internationally agreed targets on stunting and wasting in children under five years of age, and address the nutritional needs of adolescent girls, pregnant and lactating women, and older persons"]
[null,null,"2.3 by 2030 double the agricultural productivity and the incomes of small-scale food producers, particularly women, indigenous peoples, family farmers, pastoralists and fishers, including through secure and equal access to land, other productive resources and inputs, knowledge, financial services, markets, and opportunities for value addition and non-farm employment"]
[null,null,"2.4 by 2030 ensure sustainable food production systems and implement resilient agricultural practices that increase productivity and production, that help maintain ecosystems, that strengthen capacity for adaptation to climate change, extreme weather, drought, flooding and other disasters, and that progressively improve land and soil quality"]
[null,null,"2.5 by 2020 maintain genetic diversity of seeds, cultivated plants, farmed and domesticated animals and their related wild species, including through soundly managed and diversified seed and plant banks at national, regional and international levels, and promote access to and fair and equitable sharing of benefits arising from the utilization of genetic resources and associated traditional knowledge as internationally agreed"]
[null,null,"2.a correct and prevent trade restrictions and distortions in world agricultural markets including by the parallel elimination of all forms of agricultural export subsidies and all export measures with equivalent effect, in accordance with the mandate of the Doha Development Round"]
[null,null,"2.b adopt measures to ensure the proper functioning of food commodity markets and their derivatives, and facilitate timely access to market information, including on food reserves, in order to help limit extreme food price volatility"]
["GOAL 3","Attain healthy lives and promote well-being for all at all ages","3.1 by 2030 reduce the global maternal mortality ratio to less than 70 per 100,000 live births"]
[null,null,"3.2 by 2030 end preventable deaths of newborns and and children under 5 years of age, with all countries aiming to reduce neonatal mortality to at least as low as 12 per 1,000 live births and under-5 mortality to at least as low as 25 per 1,000 live births"]
[null,null,"3.3 by 2030 end the epidemics of AIDS, tuberculosis, malaria, and neglected tropical diseases and combat hepatitis, water-borne diseases, and other communicable diseases"]
[null,null,"3.4 by 2030 reduce by one-third pre-mature mortality from non-communicable diseases through prevention and treatment, and promote mental health and wellbeing"]
[null,null,"3.5 strengthen the prevention and treatment of substance abuse, including narcotic drug abuse and harmful use of alcohol"]
[null,null,"3.6 by 2020 halve the number of global deaths and injuries from road traffic accidents"]
[null,null,"3.7 by 2030 ensure universal access to sexual and reproductive health care services, including for family planning, information and education, and the integration of reproductive health into national strategies and programmes"]
[null,null,"3.8 achieve universal health coverage, including financial risk protection, access to quality essential health care services, and access to safe, effective, quality, and affordable essential medicines and vaccines for all"]
[null,null,"3.9 by 2030 substantially reduce the number of deaths and illnesses from hazardous chemicals and air, water, and soil pollution and contamination"]
[null,null,"3.a strengthen implementation of the World Health Organization Framework Convention on Tobacco Control in all countries, as appropriate"]
[null,null,"3.b support research and development of vaccines and medicines for the communicable and non-communicable diseases that primarily affect developing countries, provide access to affordable essential medicines and vaccines, in accordance with the Doha Declaration and theTRIPS Agreement and Public Health, which affirms the right of developing countries to use to the full the provisions in the Agreement on Trade Related Aspects of Intellectual Property Rights regarding flexibilities to protect public health and, in particular, provide access to medicines for all"]
[null,null,"3.c substantially increase health financing and the recruitment, development and training and retention of the health workforce in developing countries, especially in LDCs and SIDS"]
[null,null,"3.d strengthen the capacity of all countries, particularly developing countries, for early warning, risk reduction, and management of national and global health risks"]
["GOAL 4","Achieve gender equality and empower all women and girls","4.1 by 2030, ensure that all girls and boys complete free, equitable and quality primary and secondary education leading to relevant and effective learning outcomes"]
[null,null,"4.2 by 2030 ensure that all girls and boys have access to quality early childhood development, care and preprimary education so that they are ready for primary education"]
[null,null,"4.3 by 2030 ensure equal access for all women and men to affordable quality technical, vocational and tertiary education, including university"]
[null,null,"4.4 by 2030, substantially increase the number of youth and adults who have relevant skills, including technical and vocational skills, for employment, decent jobs and entrepreneurship"]
[null,null,"4.5 by 2030, eliminate gender disparities in education and ensure equal access to all levels of education and vocational training for the vulnerable, including persons with disabilities, indigenous peoples, and children in vulnerable situations"]
[null,null,"4.6 by 2030 ensure that all youth and at a substantial propotion of adults, both men and women, achieve literacy and numeracy"]
[null,null,"4.7 by 2030 ensure all learners acquire the knowledge and skills needed to promote sustainable development, including among others through education for sustainable development and sustainable lifestyles, human rights, gender equality, promotion of a culture of peace and non-violence, global citizenship, and appreciation of cultural diversity and of culture’s contribution to sustainable development"]
[null,null,"4.a build and upgrade education facilities that are child, disability and gender sensitive and provide safe, non-violent, inclusive and effective learning environments for all"]
[null,null,"4.b by 2020 substantially expand globally the number of scholarships available to developing countries in particular LDCs, SIDS and African countries for enrolment in higher education, including vocational training, ICT, technical, engineering and scientific programmes in developed countries and other developing countries"]
[null,null,"4.c by 2030 substantially increase the supply of qualified teachers, including through international cooperation for teacher training in developing countries, especially LDCs and SIDS"]
["GOAL 5","Achieve gender equality and empower all women and girls","5.1 end all forms of discrimination against all women and girls everywhere"]
[null,null,"5.2 eliminate all forms of violence against all women and girls in the public and private spheres, including trafficking and sexual and other types of exploitation"]
[null,null,"5.3 eliminate all harmful practices, such as child, early and forced marriage and female genital mutilations"]
[null,null,"5.4 recognize and value unpaid care and domestic work through the provision of public services, infrastructure and social protection policies, and the promotion of shared responsibility within the household and the family as nationally appropriate"]
[null,null,"5.5 ensure women’s full and effective participation and equal opportunities for leadership at all levels of decision-making in political, economic, and public life"]
[null,null,"5.6 ensure universal access to sexual and reproductive health and reproductive rights as agreed in accordance with the Programme of Action of the International Conference on Population and Development and the Beijing Platform for Action and the outcome documents of their review conferences"]
[null,null,"5.a undertake reforms to give women equal rights to economic resources, as well as access to ownership and control over land and other forms of property, financial services, inheritance, and natural resources in accordance with national laws"]
[null,null,"5.b enhance the use of enabling technologies, in particular ICT, to promote the empowerment of women"]
[null,null,"5.c adopt and strengthen sound policies and enforceable legislation for the promotion of gender equality and the empowerment of all women and girls at all levels"]
["GOAL 6","Ensure access to water and sanitation for all","6.1 by 2030, achieve universal and equitable access to safe and affordable drinking water for all"]
[null,null,"6.2 by 2030, achieve access to adequate and equitable sanitation and hygiene for all, and end open defecation, paying special attention to the needs of women and girls and those in vulnerable situations"]
[null,null,"6.3 by 2030, improve water quality by reducing pollution, eliminating dumping and minimizing release of hazardous chemicals and materials, halving the proportion of untreated wastewater, and substantially increasing recycling and safe reuse globally"]
[null,null,"6.4 by 2030, substantially increase water-use efficiency across all sectors and ensure sustainable withdrawals and supply of freshwater to address water scarcity, and substantially reduce the number of people suffering from water scarcity"]
[null,null,"6.5 by 2030 implement integrated water resources management at all levels, including through transboundary cooperation as appropriate"]
[null,null,"6.6 by 2020 protect and restore water-related ecosystems, including mountains, forests, wetlands, rivers, aquifers and lakes"]
[null,null,"6.a by 2030, expand international cooperation and capacity-building support to developing countries in water and sanitation related activities and programmes, including water harvesting, desalination, water efficiency, wastewater treatment, recycling and reuse technologies"]
[null,null,"6.b support and strengthen the participation of local communities for improving water and sanitation management"]
["GOAL 7","Ensure access to affordable, reliable, sustainable and modern energy for all","7.1 by 2030, ensure universal access to affordable, reliable, and modern energy services"]
[null,null,"7.2 by 2030, increase substantially the share of renewable energy in the global energy mix "]
[null,null,"7.3 by 2030, double the global rate of improvement in energy efficiency"]
[null,null,"7.a by 2030 enhance international cooperation to facilitate access to clean energy research and technology, including renewable energy, energy efficiency, and advanced and cleaner fossil fuel technology, and promote investment in energy infrastructure and clean energy technologies"]
[null,null,"7.b by 2030 expand infrastructure and upgrade technology for supplying modern and sustainable energy services for all in developing countries, in particular LDCs, SIDS, and land-locked developing countries, in accordance with their respective programmes of support "]
["GOAL 8","Promote inclusive and sustainable economic growth, employment and decent work for all","8.1 sustain per capita economic growth in accordance with national circumstances, and in particular at least 7 per cent GDP growth per annum in the least-developed countries"]
[null,null,"8.2 achieve higher levels of economic productivity through diversification, technological upgrading and innovation, including through a focus on high value added and labour-intensive sectors"]
[null,null,"8.3 promote development-oriented policies that support productive activities, decent job creation, entrepreneurship, creativity and innovation, and encourage formalization and growth of micro-, small- and medium-sized enterprises including through access to financial services"]
[null,null,"8.4 improve progressively through 2030 global resource efficiency in consumption and production, and endeavour to decouple economic growth from environmental degradation in accordance with the 10-year framework of programmes on sustainable consumption and production with developed countries taking the lead"]
[null,null,"8.5 by 2030 achieve full and productive employment and decent work for all women and men, including for young people and persons with disabilities, and equal pay for work of equal value"]
[null,null,"8.6 by 2020 substantially reduce the proportion of youth not in employment, education or training"]
[null,null,"8.7 take immediate and effective measures to eradicate forced labour, end modern slavery and human trafficking and secure the prohibition and elimination of the worst forms of child labour, including recruitment and use of child soldiers, and by 2025, end child labour in all its forms "]
[null,null,"8.8 protect labour rights and promote safe and secure working environments of all workers, including migrant workers, particularly women migrants, and those in precarious employment"]
[null,null,"8.9 by 2030 devise and implement policies to promote sustainable tourism which creates jobs, promotes local culture and products"]
[null,null,"8.10 strengthen the capacity of domestic financial institutions to encourage and to expand access to banking, insurance and financial services for all"]
[null,null,"8.a increase Aid for Trade support for developing countries, in particular LDCs, including through the Enhanced Integrated Framework for Trade-Related Technical Assistance to  LDCs"]
[null,null,"8.b by 2020 develop and operationalize a global strategy for youth employment and implement the Global Jobs Pact of the International Labour Organization"]
["GOAL 9","Build resilient infrastructure, promote sustainable industrialization and foster innovation","9.1 develop quality, reliable, sustainable and resilient infrastructure, including regional and trans-border infrastructure, to support economic development and human well-being, with a focus on affordable and equitable access for all"]
[null,null,"9.2 promote inclusive and sustainable industrialization, and by 2030  significantly raise industry’s share of employment and GDP in line with national circumstances, and double its share in LDCs"]
[null,null,"9.3 increase the access of small-scale industrial and other enterprises, particularly in developing countries, to financial services including affordable credit and their integration into value chains and markets"]
[null,null,"9.4 by 2030 upgrade infrastructure and retrofit industries to make them sustainable, with increased resource use efficiency and greater adoption of clean and environmentally sound technologies and industrial processes, all countries taking action in accordance with their respective capabilities"]
[null,null,"9.5 enhance scientific research, upgrade the technological capabilities of industrial sectors in all countries, particularly developing countries, including by 2030 encouraging innovation and increasing the number of research and development  per one million people and public and private research and development spending"]
[null,null,"9.a facilitate sustainable and resilient infrastructure development in developing countries through enhanced financial, technological and technical support to African countries, LDCs, LLDCs and SIDS"]
[null,null,"9.b support domestic technology development, research and innovation in developing countries including by ensuring a conducive policy environment for inter alia industrial diversification and value addition to commodities"]
[null,null,"9.c significantly increase access to ICT and strive to provide universal and affordable access to internet in LDCs by 2020"]
["GOAL 10","Reduce inequality within and among countries","10.1 by 2030 progressively achieve and sustain income growth of the bottom 40 per cent of the population at a rate higher than the national average"]
[null,null,"10.2 by 2030 empower and promote the social, economic and political inclusion of all irrespective of age, sex, disability, race, ethnicity, origin, religion or economic or other status"]
[null,null,"10.3 ensure equal opportunity and reduce inequalities of outcome, including through eliminating discriminatory laws, policies and practices and promoting appropriate legislation, policies and actions in this regard"]
[null,null,"10.4 adopt policies especially fiscal, wage, and social protection policies and progressively achieve greater equality"]
[null,null,"10.5 improve regulation and monitoring of global financial markets and institutions and strengthen implementation of such regulations"]
[null,null,"10.6 ensure enhanced representation and voice of developing countries in decision making in global international economic and financial institutions in order to deliver more effective, credible, accountable and legitimate institutions"]
[null,null,"10.7 facilitate orderly, safe, regular and responsible migration and mobility of people, including through implementation of planned and well-managed migration policies"]
[null,null,"10.a implement the principle of special and differential treatment for developing countries, in particular least developed countries, in accordance with WTO agreements"]
[null,null,"10.b encourage ODA and financial flows, including foreign direct investment, to states where the need is greatest, in particular LDCs, African countries, SIDS, and LLDCs, in accordance with their national plans and programmes"]
[null,null,"10.c by 2030, reduce to less than 3 per cent the transaction costs of migrant remittances and eliminate remittance corridors with costs higher than 5 per cent"]
["GOAL 11","Make cities inclusive, safe, resilient and sustainable","11.1 by 2030, ensure access for all to adequate, safe and affordable housing and basic services, and upgrade slums"]
[null,null,"11.2 by 2030, provide access to safe, affordable, accessible and sustainable transport systems for all, improving road safety, notably by expanding public transport, with special attention to the needs of those in vulnerable situations, women, children, persons with disabilities and older persons"]
[null,null,"11.3 by 2030 enhance inclusive and sustainable urbanization and capacities for participatory, integrated and sustainable human settlement planning and management in all countries"]
[null,null,"11.4 strengthen efforts to protect and safeguard the world’s cultural and natural heritage"]
[null,null,"11.5 by 2030 significantly reduce the number of deaths and the number of people affected and substantially decrease the direct economic losses relative to GDP caused by disasters, including water-related disasters, with a focus on protecting the poor and people in vulnerable situations"]
[null,null,"11.6 by 2030, reduce the adverse per capita environmental impact of cities, including by paying special attention to air quality, municipal and other waste management"]
[null,null,"11.7 by 2030, provide universal access to safe, inclusive and accessible, green and public spaces, particularly for women and children, older persons and persons with disabilities"]
[null,null,"11.a support positive economic, social and environmental links between urban, peri-urban and rural areas by strengthening national and regional development planning"]
[null,null,"11.b by 2020, substantially increase the number of cities and human settlements adopting and implementing integrated policies and plans towards inclusion, resource efficiency, mitigation and adaptation to climate change, resilience to disasters, develop and implement in line with the Sendai Framework for Disaster Risk Reduction 2015-2030, holistic disaster risk management at all levels"]
[null,null,"11.c support least developed countries, including through financial and technical assistance, for sustainable and resilient buildings utilizing local materials"]
["GOAL 12","Ensure sustainable consumption and production patterns","12.1 implement the 10-Year Framework of Programmes on sustainable consumption and production, all countries taking action, with developed countries taking the lead, taking into account the development and capabilities of developing countries"]
[null,null,"12.2 by 2030 achieve sustainable management and efficient use of natural resources"]
[null,null,"12.3 by 2030 halve per capita global food waste at the retail and consumer levels, and reduce food losses along production and supply chains including post-harvest losses"]
[null,null,"12.4 by 2020 achieve environmentally sound management of chemicals and all wastes throughout their life cycle in accordance with agreed international frameworks and significantly reduce their release to air, water and soil in order to minimize their adverse impacts on human health and the environment"]
[null,null,"12.5 by 2030, substantially reduce waste generation through prevention, reduction, recycling, and reuse"]
[null,null,"12.6 encourage companies, especially large and trans-national companies, to adopt sustainable practices and to integrate sustainability information into their reporting cycle"]
[null,null,"12.7 promote public procurement practices that are sustainable in accordance with national policies and priorities"]
[null,null,"12.8 by 2030 ensure that people everywhere have the relevant information and awareness for sustainable development and lifestyles in harmony with nature"]
[null,null,"12.a support developing countries to strengthen their scientific and technological capacity to move towards more sustainable patterns of consumption and production"]
[null,null,"12.b develop and implement tools to monitor sustainable development impacts for sustainable tourism which creates jobs, promotes local culture and products"]
[null,null,"12.c rationalize inefficient fossil fuel subsidies that encourage wasteful consumption by removing market distortions, in accordance with national circumstances, including by restructuring taxation and phasing out those harmful subsidies, where they exist, to reflect their environmental impacts, taking fully into account the specific needs and conditions of developing countries and minimizing the possible adverse impacts on their development in a manner that protects the poor and the affected communities"]
["GOAL 13","Take urgen action to combat climate change and its impacts","13.1 strengthen resilience and adaptive capacity to climate related hazards and natural disasters in all countries"]
[null,null,"13.2 integrate climate change measures into national policies, strategies, and planning"]
[null,null,"13.3 improve education, awareness raising and human and institutional capacity on climate change mitigation, adaptation, impact reduction, and early warning"]
[null,null,"13.a implement the commitment undertaken by developed country Parties to the UNFCCC to a goal of mobilizing jointly USD100 billion annually by 2020 from all sources to address the needs of developing countries in the context of meaningful mitigation actions and transparency on implementation and fully operationalize the Green Climate Fund through its capitalization as soon as possible"]
[null,null,"13.b Promote mechanisms for raising capacities for effective climate change related planning and management, in LDCs, including focusing on women, youth, local and marginalized communities         "]
["GOAL 14","Conserve and sustainably use the oceans, seas and marine resources","14.1 by 2025, prevent and significantly reduce marine pollution of all kinds, particularly from land-based activities, including marine debris and nutrient pollution"]
[null,null,"14.2 by 2020, sustainably manage and protect marine and coastal ecosystems to avoid significant adverse impacts, including by strengthening their resilience, and take action for their restoration, in order to achieve healthy and productive oceans"]
[null,null,"14.3 minimize and address the impacts of ocean acidification, including through enhanced scientific cooperation at all levels"]
[null,null,"14.4 by 2020, effectively regulate harvesting, and end overfishing, illegal, unreported and unregulated fishing and destructive fishing practices and implement science-based management plans, to restore fish stocks in the shortest time feasible at least to levels that can produce maximum sustainable yield as determined by their biological characteristics"]
[null,null,"14.5 by 2020, conserve at least 10 per cent of coastal and marine areas, consistent with national and international law and based on best available scientific information"]
[null,null,"14.6 by 2020, prohibit certain forms of fisheries subsidies which contribute to overcapacity and overfishing, and eliminate subsidies that contribute to illegal, unreported and unregulated fishing, and refrain from introducing new such subsidies, recognizing that appropriate and effective special and differential treatment for developing and least developed countries should be an integral part of the WTO fisheries subsidies negotiation *"]
[null,null,"14.7 by 2030 increase the economic benefits to SIDS and LDCs from the sustainable use of marine resources, including through sustainable management of fisheries, aquaculture and tourism"]
[null,null,"14.a increase scientific knowledge, develop research capacities and transfer marine technology taking into account the Intergovernmental Oceanographic Commission Criteria and Guidelines on the Transfer of Marine Technology, in order to improve ocean health and to enhance the contribution of marine biodiversity to the development of developing countries, in particular SIDS and LDCs"]
[null,null,"14.b provide access of small-scale artisanal fishers to marine resources and markets"]
[null,null,"14.c enhance the conversation and sustainable use of oceans and their resources by implementing international law, as reflected in UNCLOS, which provides the legal framework for the conversation and sustainable use of oceans and their resources as recalled in paragraph 158 of the Future We Want"]
["GOAL 15","Sustainably manage forests, combat desertification, halt and reverse land degradation, halt biodiversity loss","15.1 by 2020 ensure conservation, restoration and sustainable use of terrestrial and inland freshwater ecosystems and their services, in particular forests, wetlands, mountains and drylands, in line with obligations under international agreements"]
[null,null,"15.2 by 2020, promote the implementation of sustainable management of all types of forests, halt deforestation, restore degraded forests, and increase afforestation and reforestation globally"]
[null,null,"15.3 by 2020, combat desertification, and restore degraded land and soil, including land affected by desertification, drought and floods, and strive to achieve a land-degradation neutral world"]
[null,null,"15.4 by 2030 ensure the conservation of mountain ecosystems, including their biodiversity, in order to enhance their capacity to provide benefits which are essential for sustainable development"]
[null,null,"15.5 take urgent and significant action to reduce degradation of natural habitat, halt the loss of biodiversity, and by 2020 protect and prevent the extinction of threatened species"]
[null,null,"15.6 promote fair and equitable sharing of the benefits arising from the utilization of genetic resources, and promote appropriate access to such resources, as internationally agreed"]
[null,null,"15.7 take urgent action to end poaching and trafficking of protected species of flora and fauna, and address both demand and supply of illegal wildlife products"]
[null,null,"15.8 by 2020 introduce measures to prevent the introduction and significantly reduce the impact of invasive alien species on land and water ecosystems, and control or eradicate the priority species"]
[null,null,"15.9 by 2020, integrate ecosystems and biodiversity values into national and local planning, development processes and poverty reduction strategies, and accounts"]
[null,null,"15.a mobilize and significantly increase financial resources from all sources to conserve and sustainably use biodiversity and ecosystems"]
[null,null,"15.b mobilize significantly resources from all sources and at all levels to finance sustainable forest management, and provide adequate incentives to developing countries to advance sustainable forest management, including for conservation and reforestation"]
[null,null,"15.c enhance global support to efforts to combat poaching and trafficking of protected species, including by increasing the capacity of local communities to pursue sustainable livelihood opportunities"]
["GOAL 16","Promote just, peaceful and inclusive societies","16.1 significantly reduce all forms of violence and related death rates everywhere"]
[null,null,"16.2 end abuse, exploitation, trafficking and all forms of violence against and torture of children"]
[null,null,"16.3 promote the rule of law at the national and international levels, and ensure equal access to justice for all"]
[null,null,"16.4 by 2030 significantly reduce illicit financial and arms flows, strengthen recovery and return of stolen assets, and combat all forms of organized crime"]
[null,null,"16.5 substantially reduce corruption and bribery in all its forms"]
[null,null,"16.6 develop effective, accountable and transparent institutions at all levels"]
[null,null,"16.7 ensure responsive, inclusive, participatory and representative decision-making at all levels"]
[null,null,"16.8 broaden and strengthen the participation of developing countries in the institutions of global governance"]
[null,null,"16.9 by 2030 provide legal identity for all, including birth registration"]
[null,null,"16.10 ensure public access to information and protect fundamental freedoms, in accordance with national legislation and international agreements"]
[null,null,"16.a strengthen relevant national institutions, including through international cooperation, for building capacities at all levels, in particular in developing countries, to prevent violence and combat terrorism and crime"]
[null,null,"16.b promote and enforce non-discriminatory laws and policies for sustainable development"]
["GOAL 17","Revitalize the global partnership for sustainable development","Finance"]
[null,null,"17.1 strengthen domestic resource mobilization, including through international support to developing countries to improve domestic capacity for tax and other revenue collection"]
[null,null,"17.2 developed countries to implement fully their ODA commitments, including the commitment by many developed countries to achieve the target of 0.7 per cent of ODA/GNI to developing countries and 0.15 to 0.20 er cent of ODA/GNI to LDCs; ODA providers are encouraged to consider setting a target to provide at least 0.20 per cent of ODA/GNI to LDCs"]
[null,null,"17.3 mobilize additional financial resources for developing countries from multiple sources"]
[null,null,"17.4 assist developing countries in attaining long-term debt sustainability through coordinated policies aimed at fostering debt financing, debt relief and debt restructuring, as appropriate, and address the external debt of highly indebted poor countries to reduce debt distress"]
[null,null,"17.5 adopt and implement investment promotion regimes for LDCs"]
[null,null,"Technology"]
[null,null,"17.6 enhance North-South, South-South and triangular regional and international cooperation on and access to science, technology and innovation, and enhance knowledge sharing on mutually agreed terms, including through improved coordination among existing mechanisms, in particular at the UN level, and through a global technology facilitation mechanism "]
[null,null,"17.7 promote development, transfer, dissemination and diffusion of environmentally sound technologies to developing countries on favourable terms, including on concessional and preferential terms, as mutually agreed"]
[null,null,"17.8 fully operationalize the Technology Bank and Science, Technology and Innovation capacity building mechanism for LDCs by 2017, and enhance the use of enabling technologies in particular ICT"]
[null,null,"Capacity building"]
[null,null,"17.9 enhance international support for implementing effective and targeted capacity building in developing countries to support national plans to implement all the sustainable development goals, including through North-South, South-South, and triangular cooperation"]
[null,null,"Trade"]
[null,null,"17.10 promote a universal, rules-based, open, non-discriminatory and equitable multilateral trading system under the WTO including through the conclusion of negotiations within its Doha Development Agenda"]
[null,null,"17.11 significantly increase the exports of developing countries, in particular with a view to doubling the LDC share of global exports by 2020"]
[null,null,"17.12 realize timely implementation of duty-free, quota-free market access on a lasting basis for all LDCs consistent with WTO decisions, including by ensuring that preferential rules of origin applicable to imports from LDCs are transparent and simple, and contribute to facilitating market access"]
[null,null,"Systemic issues"]
[null,null,"Policy and institutional coherence"]
[null,null,"17.13 enhance global macroeconomic stability including through policy coordination and policy coherence"]
[null,null,"17.14 enhance policy coherence for sustainable development"]
[null,null,"17.15 respect each country’s policy space and leadership to establish and implement policies for poverty eradication and sustainable development"]
[null,null,"Multi-stakeholder partnerships"]
[null,null,"17.16 enhance the global partnership for sustainable development, complemented by multi-stakeholder partnerships that mobilize and share knowledge, expertise, technology and financial resources to support the achievement of sustainable development goals in all countries, particularly developing countries"]
[null,null,"17.17 encourage and promote effective public, public-private, and civil society partnerships, building on the experience and resourcing strategies of partnerships"]
[null,null,"Data, monitoring and accountability"]
[null,null,"17.18 by 2020, enhance capacity building support to developing countries, including for LDCs and SIDS, to increase significantly the availability of high-quality, timely and reliable data disaggregated by income, gender, age, race, ethnicity, migratory status, disability, geographic location and other characteristics relevant in national contexts"]
[null,null,"17.19 by 2030, build on existing initiatives to develop measurements of progress on sustainable development that complement GDP, and support statistical capacity building in developing countries"]

{"sheet":"Instructions","index":2,"n_rows":112,"n_cols":2,"rows_kept":112,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Instructions"]
[]
[null,"Step wise instruction for users to fill the subsequent Tabs"]
[]
[null,"Important information to note: the steps below are for each intervention, NAMA implementor needs to collate the information from  each intervention"]
[]
[null,"Tab: Selection of indicators"]
[null,"Step 1: Identify all the positive and negative impacts of the intervention/NAMA and place all the identified impacts against the respective domains and indicator list. Mark the Column \"Selected\" as yes or no if the indicator is relevant to the intervention or not. You can identify the indicator also based on Relevance to SDG goals."]
[null,"Step 2: After placing the identified impacts against the respective indicators, provide justification for the each indicator and state whether this indicator will be selected or not. Select at least one indicator per domain and mark the last column as yes or no against the selected indicator (This is done to cross check the intervention tab)"]
[null,"Step 3: After step 2, follow the drop down list in column F \"Effect on indicator\" and classify the effect as Positive, Negative or Both. It is important for all Intervention Implementers to list the effects to the best possible way. Also, note: Negative impacts need to be mitigated and monitored (unless a strong argument is given for non monitoring)"]
[null,"Replicate the above steps if the NAMA has more than 1 intervention"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Tab: Intervention"]
[null,"Step 1: Based on Indicator selection in the pervious tab, select the number of parameters, the parameter type and effect from the drop down list for each indicator being monitored. Put NA (Not Applicable) for indicators which are not being monitored in column number of parameters selected. Also note that if the Nama implementor does not find a suitable parameter from the drop down list, they may add the relevant parameter in the column \"other parameters\"."]
[null,"Step 2: For the parameter identified, please indicate the measurement value  in column G ( for example whether it will be measured via  a literature value or through a survey, etc etc). Intervention Implementer can define the best possible way of measurement."]
[null,"Step 3: Indicate in column H if the indicated measurement way is a direct or an indirect way via the drop down list. Implementers may note that the way defined in this column will be observed during both the baseline and project. In case there is a change in the project measurement type, Implementers should specify that by adding a column next to project values and indicate the reason for this change."]
[null,"Step 4: MRV, Baseline values  and Intervention values should be linked to the next two tabs. "]
[null,"Step 5: Each implementor needs to  put the target value to be achieved for each parameter/indicator in column J. Target value will be defined by the NAMA developer"]
[null,"Step 6: Indicate the unit of measurement of each parameter being monitored in column L"]
[null,"Step 7: Calculation of NAI's - Once the implementor fills in baseline, project and target values, NAI estimated, NAI -ex post and success of the NAMA is calculated automatically in column M, N , O respectively."]
[null,"Replicate the above steps and add more sheets; if the NAMA has more than 1 intervention"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Tab: MRV"]
[null,"Step 1: Replicate the MRV box for each parameter being monitored."]
[null,"Step 2: Define in details the way of monitoring, who will be monitoring (it can be the Intervention implemeter) and how it will be monitored. In case of indirect measurement, please indicate the formula being used for calculations."]
[null,"Step3: Define in details the QC procedures to be followed for each parameter."]
[null,"Step 4: Link the baseline values and project values to the monitoring sheet."]
[null,"Replicate the above steps and add more sheets; if the NAMA has more than 1 intervention"]
[]
[null,"Tab: Monitoring"]
[null,"Step 1: Classify all the information needed for one intervention type such as households in intervention, number of women per households etc."]
[null,"Step 2: In case of any formulas being used, please put the formulae's into the respective cell and define the values in another column"]
[null,"Replicate the above steps and add more sheets; if the NAMA has more than 1 intervention"]
[]
[]
[null,"Guidance on monitoring"]
[]
[]
[null,"Important points to be noted:"]
[null,"Monitoring needs to be done at each intervention level. It will be intervention implementers' responsibility to assign the duties for monitoring and reporting in the MRV structure."]
[]
[null,"Surveys can be both indirect and direct way of monitoring, and Implementation agency will define how the survey will be used. Implementation agency will also draft the household survey form for each intervention. In case the implementation agency uses the census, they need the define the parameters which are taken from census and  justify the frequency defined for monitoring."]
[]
[null,"Monitoring frequency: fixed at 3 years for all the parameters."]
[]
[null,"QA/QC procedures"]
[null,"The NAMA's implementer shall establish a QA/QC system to ensure the good quality of data. The quality control (QC) procedures is used for compiling, developing and maintaining the required datasets and the quality assurance (QA) procedures for ensuring the overall quality of the datasets by assessing the conformity and the effectiveness of the QC system, based on data quality objectives and general provisions"]
[null,"For the QA/QC process, the following data quality objectives should be taken into account:"]
[null,"Relevance: collect data and information required for the establishment of baseline and mainly activity data and information applicable for the assessment of impacts"]
[null,"Completeness: include all relevant activity data and information to produce \"true and fair\" representative data"]
[null,"Consistency: present the same data in the same definition/scope/format and make the datasets compatible with other related data"]
[null,"Credibility: identify and utilize authoritative data sources. Collected data/information should always reference their sources (examples of sources: data providers, NAMA's implementer, government authorities, peer-reviewed international statistics documents, research institutes, individual academic research work institutions, technology supplier)"]
[null,"Correctness: utilize the most recent data available in a sector in order to reflect the current economic and technological practices (one to 3 years before the submission of the NAMA)."]
[null,"Accuracy: reduce errors and uncertainties as far as it is practical and cost-effective"]
[null,"Objectivity: avoid biased, prejudiced and partial information."]
[null,"Conservativeness: ensure to use a conservative approach in case of missing or incomplete data"]
[null,"Transparency: disclose sufficient and appropriate data and processes to allow monitoring of the quality of the compiled datasets"]
[null,"Traceability: document all data sources"]
[]
[null,"Sampling guidance for surveys"]
[null,"For monitoring parameters which are determined using a survey, the following guidance should be used:"]
[null,"The survey should be conducted following simple random sampling approach and the minimum sample size should be determined as per the guidelines below:"]
[null,"Project target population < 300: Minimum sampling size 30 or population size (which ever is the smallest)"]
[null,"Project target population 300 to 1000: Minimum sample size 10% of groupe size"]
[null,"Project target population > 1000: Minimum sample size 100"]

{"sheet":"Selection of indicators","index":3,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[[35,1,36,1],[0,1,0,8],[4,2,4,8],[8,1,13,1],[14,1,22,1],[23,1,30,1],[31,1,34,1]]}
[null,"Selection of indicators"]
[]
[]
[]
[null,"Intervention Name",{"$f":"Introduction!B54","v":0}]
[]
[]
[null,"Domain","Indicator","Relevance to SDG and targets","Selected (Yes/No)","Identified impacts","Explanation of chosen indicator","Effect on Indicator","Monitoring done (Yes/No)"]
[null,"Environment","Air pollution/quality","Goal 11, Target 11.6",null,"Reduced indoor pollution","The NAMA will reduce consumption of kerosene/paraffin in lanterns which are associated with severe indoor air pollution of soot and noxious fumes. \n","Positive","No"]
[null,null,"Water pollution/quality","Goal 6, Target 6.6\nGoal 11, Target 11.6\nGoal 12, Target 12.4",null,null,null,null,"No"]
[null,null,"Soil pollution/quality","Goal 2, Target 2.4\nGoal 11, Target 11.6\nGoal 12, Target 12.4",null,null,null,null,"No"]
[null,null,"Others (Noise/visibility)","Goal 11, Target 11.6",null,null,null,null,"No"]
[null,null,"Biodiversity and Ecosystem balance","Goal 14, all targets\nGoal 15, all targets",null,null,null,null,"No"]
[null,null,"Climate change adaptation and mitigation","Goal 13, all targets",null,null,null,null,"No"]
[null,"Social","Health ","Goal 3, All Targets",null,"Improvement of health and health care conditions","The NAMA will improve health of people by avoiding burning kerosene/paraffin, which causes severe indoor air pollution by emitting noxious fumes and soot. Kerosene lighting is extremely hazardous and is responsible for many burns and deaths.\n","Positive","Yes "]
[null,null,"Livelihood of poor, poverty alleviation, peace","Goal 1, All targets\nGoal 2, Target 2.1\nGoal 16, Target 16.1",null,"Poverty reduction","The NAMA will improve light conditions allowing children to study at home, which has a significant impact on improving children education in rural families and their future employability. \nKerosene/paraffin lighting is extremely hazardous and is responsible for loss of property through fire, as well as many burns and deaths. \nAllow for the implementation of safety measures such as street lighting, security lighting, remote alarm systems, electric fences, road signs, etc.,. \nPrevent loss of food thanks to opportunity to install refrigeration appliances. Promote better food processing, adding value to the agricultural products .                                                                                Promote creation of new income-generating activities thanks to electricity for lighting and running the machines.","Positive","Yes"]
[null,null,"Affordability of electricity","Goal 7, Targets 7.1",null,null,null,null,"No"]
[null,null,"Access to sanitation and clean drinking water","Goal 6,  Tagets 6.1, 6.2, 6.4, 6.5",null,null,null,null,"No"]
[null,null,"Food security (Access to land and sustainable agriculture)","Goal 2, all Targets\nGoal 12, Target 12.3",null,null,null,null,"No"]
[null,null,"Quality of employment","Goal 8, Targets 8.2, 8.3, 8.5, 8.6, 8.7, 8.8",null,null,null,null,"No"]
[null,null,"Time savings/time availability due to project","Goal 1",null,"Improved Productivity and economic diversification ","With a better light source, also adults may pursue their productive activities in the house beyond nightfall. The implementation of the NAMA will make people less dependent on the kerosene/paraffin and remove the burden of and save the time for obtaining the fuel. ","Positive","No"]
[null,null,"No child labour","Goal 8, Target 8.6",null,null,null,null,"No"]
[null,null,null,null,null,null,"\"\""]
[null,"Growth and Development","Access to clean and sustainable energy","Goal 7, Targets 7.1, 7.2, 7.3\n",null," People less dependent on fossil fuels, having access to RE electricity","Energy plays a critical role in economic development and poverty alleviation. In the absence of reliable grid electricity, people depend mostly on diesel generators and kerosene/parafin lamps for lighting.  The implementation of the NAMA will make people less dependent on expensive fuels and eliminates the need obtaining the fuel.","Positive","Yes"]
[null,null,"Education","Goal 4, All targets",null,"Better learning conditions","Enhance education by allowing studying beyond daylight, both for the children and for adults. Creating opportunity for  the adults for additional/informal education  (distance learning, e-courses) thanks to internet connection.  Introducing better learning conditions to schools, such as computer facilities, internet and distance learning if there is a lack of teachers.","Positive","Yes "]
[null,null,"Empowerment of women","Goal 4, Targets 4.3, 4.6\nGoal 5, All targets ",null,"More jobs to women","The NAMA will create opportunities for new income-generating activities for women and women associations, e.g. handicrafts, hair-dressers, small shops, sewing workshops, etc.","Positive","No"]
[null,null,"Access to sustainable technology","Goal 4, Target 4.3\nGoal 7, Targets 7a, 7b\nGoal 9, Target 9b",null,null,null,null,"No"]
[null,null,"Energy security","Goal 7, Target 7.1, 7.2, 7.3",null,"Improved energy security","The NAMA will enable use of the local energy sources, independent on the geo-political situation.","Positive","No"]
[null,null,"Capacity building","Goal 4, Target 4.3, 4.5\nGoal 6, Target 6.a",null,"Increased knowledge sharing and capacity among rural communities","The NAMA will provide capacity building on mini-grids for grid operators and community staff. The NAMA will raise awareness and engage capacity building amongst the locals for operation and maintenance of the mini-grids. ","Positive","No"]
[null,null,"Equality (quality of jobs given, job condition for men/women)","Goal 4, Targets 4.1, 4.2, 4.3, 4.7\nGoal 5, All targets\nGoal 10, Target 10.4",null,null,null,null,"No"]
[null,null,null,null,null,null,"\"\"","\"\""]
[null,"Economic","Income generation/expenditure reduction/Balance of payments","Goal 8, Targets 8.1, 8.2, 8.3, 8.4 \nGoal 10, Target 10.1",null,"Enhanced productivity, efficiency, more business opportunities     Expenditures for electricity ","The NAMA will foster productivity, increase production efficiency and production time, enable added value activities and encourage new income-generating activities.  The generation of income would enhance economic growth and provide the means to afford electricity\n","Positive","No"]
[null,null,"Asset accumulation and investments","Goal 7, Targets 7a, 7b\nGoal 9, All targets\nGoal 17",null,null,null,null,"No "]
[null,null,"Job Creation (number of men and women employed)","Goal 8, All targets",null,"Job creation","The implementation of the NAMA will require the use of several local/national entities for: RET supply and installation, mini-grid operation, entry survey, awareness rasing,  marketing, accounting                                    ","Positive","Yes"]
[]
[null,"Institutional ","Policy and planning","Goal 16- Target 16.8, 16.10. Goal 17- Target -17.10, 17.11, 17.13",null,"Professional dialogue, Awareness raising","The implementation of the NAMA will require a proper organisation structure and  management system of the involved entities, i.e. NIE, NEE, NCA","Positive","Yes"]
[null,null,"Laws and regulation","Goal 16- Target 16.8, 16.10. Goal 17- Target -17.10, 17.11, 17.13",null,"Enhance proper operation management ","An establishe operation management system including manuals and process description by NIE, including NEE reporting procedures will enable a proper  implementation and monitoring of the interventions","Positive","Yes"]

{"sheet":"Intervention 1 ","index":4,"n_rows":61,"n_cols":16,"rows_kept":61,"cut":false,"hidden":true,"merged":[[4,8,5,8],[4,15,5,15],[4,16,5,16],[16,3,17,3],[18,3,19,3],[10,3,11,3],[12,3,13,3],[6,3,7,3],[8,3,9,3],[4,11,5,11],[30,3,31,3],[22,3,23,3],[16,2,17,2],[20,2,21,2],[28,3,29,3],[24,3,25,3],[28,2,29,2],[26,2,27,2],[24,2,25,2],[22,2,23,2],[4,17,5,17],[4,9,5,9],[4,13,5,13],[4,10,5,10],[4,12,5,12],[4,14,5,14],[48,2,49,2],[30,1,43,1],[44,1,49,1],[32,2,33,2],[34,2,35,2],[36,2,37,2],[42,2,43,2],[44,2,45,2],[46,2,47,2],[30,2,31,2],[38,2,39,2],[40,2,41,2],[48,3,49,3],[32,3,33,3],[34,3,35,3],[36,3,37,3],[42,3,43,3],[44,3,45,3],[46,3,47,3],[40,3,41,3],[38,3,39,3],[1,3,1,7],[4,1,5,1],[4,2,5,2],[4,7,5,7],[4,3,4,6],[16,1,29,1],[26,3,27,3],[18,2,19,2],[14,3,15,3],[20,3,21,3],[6,1,15,1],[6,2,7,2],[8,2,9,2],[10,2,11,2],[12,2,13,2],[14,2,15,2]]}
[]
[null,null,"Intervention Name"]
[]
[]
[null,"Domain","Indicator","Parameter Selection",null,null,null,"Measurement value","Measurement type","Baseline Value","Target value estimated (ex-ante) ","Intervention Value monitored (ex-post)","Unit","NAIs estimated      (ex-ante) ","NAIs monitored          (ex-post)","Evaluation of     Project Success"]
[null,null,null,"Number of parameters selected per indicator","Parameter name","Other Parameters","Effect"]
[" ","Environment","Air pollution/quality",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G7=\"+\",ROUNDUP(ABS((K7-J7)/(L7-J7)*5),0),IF(G7=\"-\",-ROUNDUP(ABS((K7-J7)/(L7-J7)*5),0),0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Water pollution/quality",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Soil pollution/quality",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Others (Noise/visibility)",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Biodiversity and Ecosystem balance",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Social","Health ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Livelihood of poor, poverty alleviation, peace",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Affordability of electricity"]
[]
[null,null,"Access to Sanitation and clean drinking water",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G23=\"+\",ROUNDUP(ABS((K23-J23)/(L23-J23)*5),0),IF(G23=\"-\",-ROUNDUP(ABS((K23-J23)/(L23-J23)*5),0),0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G24=\"+\",ROUNDUP(ABS((K24-J24)/(L24-J24)*5),0),IF(G24=\"-\",-ROUNDUP(ABS((K24-J24)/(L24-J24)*5),0),0))","v":0}]
[null,null,"Food security (Access to land and sustainable agriculture)",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G25=\"+\",ROUNDUP(ABS((K25-J25)/(L25-J25)*5),0),IF(G25=\"-\",-ROUNDUP(ABS((K25-J25)/(L25-J25)*5),0),0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G26=\"+\",ROUNDUP(ABS((K26-J26)/(L26-J26)*5),0),IF(G26=\"-\",-ROUNDUP(ABS((K26-J26)/(L26-J26)*5),0),0))","v":0}]
[null,null,"Quality of employment"]
[]
[null,null,"Time savings/time availability due to project",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G29=\"+\",ROUNDUP(ABS((K29-J29)/(L29-J29)*5),0),IF(G29=\"-\",-ROUNDUP(ABS((K29-J29)/(L29-J29)*5),0),0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Growth and Development","Access to clean and sustainable energy",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Education",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Empowerment of women",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Access to sustainable technology, Capacity development",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Energy security"]
[]
[null,null,"Capacity building"]
[]
[null,null,"Equality (quality of jobs given, job condition for men/women)",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G43=\"+\",ROUNDUP(ABS((K43-J43)/(L43-J43)*5),0),IF(G43=\"-\",-ROUNDUP(ABS((K43-J43)/(L43-J43)*5),0),0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Economic","Income generation/expenditure reduction/Balance of payments",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Asset accumulation and investments",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Job Creation (number of men and women employed)",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[]
[null,null,"NAI","positive","negative"]
[null,null,"Environment",{"$f":"SUMIF(G7:G16,\"+\",N7:N16)","v":0},{"$f":"SUMIF(G7:G16,\"-\",N7:N16)","v":0}]
[null,null,"Social",{"$f":"SUMIF(G17:G30,\"+\",N17:N30)","v":0},{"$f":"SUMIF(G17:G24,\"-\",N17:N29)","v":0}]
[null,null,"Growth and Development",{"$f":"SUMIF(G31:G44,\"+\",N31:N44)","v":0},{"$f":"SUMIF(G31:G44,\"-\",N31:N44)","v":0}]
[null,null,"Economic",{"$f":"SUMIF(G45:G50,\"+\",N45:N50)","v":0},{"$f":"SUMIF(G45:G50,\"-\",N45:N50)","v":0}]
[null,null,"Total",{"$f":"SUM(D57:D60)","v":0},{"$f":"SUM(E57:E60)","v":0}]

{"sheet":"Intervention 1","index":5,"n_rows":81,"n_cols":15,"rows_kept":81,"cut":false,"hidden":false,"merged":[[59,10,59,11],[56,3,59,3],[31,10,31,11],[45,10,45,11],[52,10,52,11],[46,1,52,1],[46,2,47,2],[46,3,47,3],[48,2,49,2],[48,3,49,3],[50,2,52,2],[50,3,52,3],[32,2,33,2],[32,3,33,3],[32,1,45,1],[36,2,37,2],[36,3,37,3],[38,2,39,2],[38,3,39,3],[40,2,41,2],[40,3,41,3],[42,2,43,2],[42,3,43,3],[34,2,35,2],[44,2,45,2],[44,3,45,3],[34,3,35,3],[4,15,5,15],[4,16,5,16],[6,2,7,2],[6,3,7,3],[8,2,9,2],[8,3,9,3],[4,12,5,12],[4,13,5,13],[4,3,4,5],[4,6,5,6],[4,10,5,10],[1,3,1,7],[4,1,5,1],[4,2,5,2],[4,7,5,7],[12,2,13,2],[12,3,13,3],[10,3,11,3],[10,2,11,2],[14,2,15,2],[14,3,15,3],[6,1,17,1],[4,14,5,14],[16,3,17,3],[16,2,17,2],[4,11,5,11],[4,8,5,8],[4,9,5,9],[18,1,31,1],[18,2,19,2],[18,3,19,3],[20,2,21,2],[20,3,21,3],[22,2,23,2],[22,3,23,3],[24,2,25,2],[24,3,25,3],[26,2,27,2],[26,3,27,3],[28,2,29,2],[28,3,29,3],[30,2,31,2],[30,3,31,3]]}
[]
[null,null,"Intervention Name",{"$f":"Introduction!B53","v":"Mini grid "}]
[]
[]
[null,"Domain","Indicator","Parameter Selection",null,null,"Measurement value","Measurement type","Baseline Value","Target value estimated (ex-ante) ","Intervention Value monitored (ex-post)","Unit","NAIs estimated      (ex-ante) ","NAIs monitored          (ex-post)","Evaluation of     Project Success"]
[null,null,null,"Number of parameters selected per indicator","Parameter name","Effect"]
[" ","Environment","Air pollution/quality"]
[]
[null,null,"Water pollution/quality"]
[]
[null,null,"Soil pollution/quality"]
[]
[null,null,"Others (Noise/visibility)"]
[]
[null,null,"Biodiversity and Ecosystem balance"]
[]
[null,null,"Climate Change adaptation & Mitigation"]
[]
[null,"Social","Health ",null,"Number of public buildings electrified","+","Number of public buildings","Direct",{"$f":"'[2]Monitoring sheet'!E13","v":0},8,null,"building",{"$f":"IF(I19=0,((J19-I19)/J19),IF(F19=\"+\",(J19-I19)/I19,(I19-J19)/I19))","v":1}]
[]
[null,null,"Livelihood of poor, poverty alleviation, peace",null,"Number of households electrified","+","Number of households","Direct",{"$f":"'[2]Monitoring sheet'!E14","v":0},1054,null,"household",{"$f":"IF(I21=0,((J21-I21)/J21),IF(F21=\"+\",(J21-I21)/I21,(I21-J21)/I21))","v":1}]
[]
[null,null,"Affordability of electricity"]
[]
[null,null,"Access to Sanitation and clean drinking water"]
[]
[null,null,"Food security (Access to land and sustainable agriculture)"]
[]
[null,null,"Quality of employment"]
[]
[null,null,"Time savings/time availability due to project"]
[null,null,null,null,null,null,null,null,null,null,"Domain Average:",null,{"$f":"AVERAGE(M19:M31)","v":1}]
[null,"Growth and Development","Access to clean and sustainable energy",null,"People with access to RE electricity","+","People with access to RE electricity","Direct",{"$f":"'[2]Monitoring sheet'!E15","v":0},6300,null,"person",1]
[]
[null,null,"Education",null,"Number of schools electrified","+","Number of schools","Direct",{"$f":"'[2]Monitoring sheet'!E16","v":0},8,null,"building",{"$f":"IF(I35=0,((J35-I35)/J35),IF(F35=\"+\",(J35-I35)/I35,(I35-J35)/I35))","v":1}]
[]
[null,null,"Empowerment of women"]
[]
[null,null,"Access to sustainable technology, Capacity development"]
[]
[null,null,"Energy security"]
[]
[null,null,"Capacity building"]
[]
[null,null,"Equality (quality of jobs given, job condition for men/women)"]
[null,null,null,null,null,null,null,null,null,null,"Domain Average:",null,{"$f":"AVERAGE(M33:M45)","v":1}]
[null,"Economic","Income generation/expenditure reduction/Balance of payments",null,"New income-generating activities (businesses )","+","Number of new entrepreneurs","Direct",{"$f":"'[2]Monitoring sheet'!E17","v":0},8,null,"enterprise",{"$f":"IF(I47=0,((J47-I47)/J47),IF(F47=\"+\",(J47-I47)/I47,(I47-J47)/I47))","v":1}]
[]
[null,null,"Asset accumulation and investments"]
[]
[null,null,"Job Creation (number of men and women employed)",null,"Number of new jobs (total)","+","Number of new jobs created (total)","Direct",0,32,null,"person",{"$f":"IF(I51=0,((J51-I51)/J51),IF(F51=\"+\",(J51-I51)/I51,(I51-J51)/I51))","v":1}]
[null,null,null,null,"Number of new jobs for women","+","Number of women employed","Direct",0,16,null,"woman",{"$f":"AVERAGE(M37:M51)","v":1}]
[null,null,null,null,null,null,null,null,null,null,"Domain Average:",null,{"$f":"AVERAGE(M47:M52)","v":1}]
[null,"Institutional","Policy and planning",null,"Enabling Policy Environment","+","Organisation structure\nNCA set up proper organisation structure, inter alia nominate  human resource; modalities of communication to donors and NEE, NIE; Finance monitoring scheme","Direct",0,1,null,"system",{"$f":"AVERAGE(M39:M53)","v":1}]
[null,null,null,null,"Interministerial Dialogue ","+","Capacity development program\nCapacity development planning for institutions and companies involved in the implementation of the NAMA established by the NIE","Direct",0,1,null,"Programm"]
[null,null,null,null,"Interministerial Dialogue ","+","NIE Promotion and awareness raising campaigns (including private sector engagment) action plan developed by  by NIE","Direct",0,1,null,"campaigns",{"$f":"AVERAGE(M40:M54)","v":1}]
[null,null,"Laws and regulation",null,"Management, Coordination & Approvals NCA","+","Overall operation management system NCA\nOverall operation management system established by the NCA including management procedures, manuals and monitoring, reporting  guidelines for NIE and NEE","Direct",0,1,null,"system",{"$f":"AVERAGE(M41:M56)","v":1}]
[null,null,null,null,"Management, Coordination & Approvals NIE","+","NIE Operation management system implemented and operational\nManagement procedures are implemented in the NIE  structure, inter alia: target monitoring, fund management, auditor cooperation, monitoring data compiling; approved by NCA, and fully operational","Direct",0,1,null,"system",{"$f":"AVERAGE(M42:M57)","v":1}]
[null,null,null,null,"Management, Coordination & Approvals NEE","+","NEE Operation management system implemented and operational\nManagement procedures are implemented in the NEE structure, inter alia: data collection, technical performance reporting and approved by NIE , and fully operational","Direct",0,1,null,"system",{"$f":"AVERAGE(M43:M58)","v":1}]
[null,null,null,null,null,null,null,null,null,null,"Domain Average:",null,{"$f":"AVERAGE(M52:M58)","v":1}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Management, Coordination & Approvals NCA"]
[null,null,"Management, Coordination & Approvals NEE"]
[null,null,"Management, Coordination & Approvals NIE"]

{"sheet":"MRV_Interv1","index":6,"n_rows":164,"n_cols":4,"rows_kept":164,"cut":false,"hidden":false,"merged":[[106,2,106,3],[107,2,107,3],[108,2,108,3],[109,2,109,3],[113,2,113,3],[94,2,94,3],[95,2,95,3],[96,2,96,3],[97,2,97,3],[101,2,101,3],[82,2,82,3],[83,2,83,3],[84,2,84,3],[85,2,85,3],[89,2,89,3],[70,2,70,3],[71,2,71,3],[72,2,72,3],[73,2,73,3],[77,2,77,3],[58,2,58,3],[59,2,59,3],[60,2,60,3],[61,2,61,3],[65,2,65,3],[46,2,46,3],[47,2,47,3],[48,2,48,3],[49,2,49,3],[53,2,53,3],[33,2,33,3],[34,2,34,3],[35,2,35,3],[36,2,36,3],[40,2,40,3],[3,3,3,4],[23,2,23,3],[24,2,24,3],[21,2,21,3],[28,2,28,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[16,2,16,3],[22,2,22,3],[118,2,118,3],[119,2,119,3],[120,2,120,3],[121,2,121,3],[125,2,125,3],[130,2,130,3],[131,2,131,3],[132,2,132,3],[133,2,133,3],[137,2,137,3],[142,2,142,3],[143,2,143,3],[144,2,144,3],[145,2,145,3],[149,2,149,3],[154,2,154,3],[155,2,155,3],[156,2,156,3],[157,2,157,3],[161,2,161,3]]}
[]
[]
[]
[null,null,"Intervention Name",{"$f":"Introduction!B53","v":"Mini grid "}]
[]
[]
[]
[]
[null,"Serial number",{"$f":"+'Monitoring sheet'!A12","v":1}]
[null,"Indicator Name","Health"]
[null,"Domain","Social"]
[null,"Parameter Name","Number of public buildings electrified"]
[null,"Baseline Value",{"$f":"'[2]Monitoring sheet'!E16","v":0}]
[null,"Way of monitoring","How"]
[null,null,"Frequency","3 years"]
[null,null,"By whom","Intervention Implementer"]
[null,"Project Value",8]
[null,"QA/QC procedures"]
[null,null,"QC check done","Nama Implementer"]
[]
[null,"Serial number",{"$f":"+'Monitoring sheet'!A13","v":2}]
[null,"Indicator Name","Livelihood of the poor, poverty alleviation, peace"]
[null,"Domain","Social"]
[null,"Parameter Name","Number of households electrified "]
[null,"Baseline Value",{"$f":"'[2]Monitoring sheet'!E17","v":0}]
[null,"Way of monitoring","How"]
[null,null,"Frequency","3 years"]
[null,null,"By whom","Intervention Implementer"]
[null,"Project Value",1054]
[null,"QA/QC procedures"]
[null,null,"QC check done","Nama Implementer"]
[]
[null,"Serial number",{"$f":"+'Monitoring sheet'!A14","v":3}]
[null,"Indicator Name","Access to clean and sustainable energy"]
[null,"Domain","Growth and development"]
[null,"Parameter Name","People with access to RE electricity"]
[null,"Baseline Value",0]
[null,"Way of monitoring","How"]
[null,null,"Frequency","HH survey / National census"]
[null,null,"By whom","Intervention Implementer"]
[null,"Project Value",6300]
[null,"QA/QC procedures"]
[null,null,"QC check done","Nama Implementer"]
[]
[]
[null,"Serial number",{"$f":"+'Monitoring sheet'!A15","v":4}]
[null,"Indicator Name","Education"]
[null,"Domain","Growth and development"]
[null,"Parameter Name","Number of schools electrified"]
[null,"Baseline Value",0]
[null,"Way of monitoring","How"]
[null,null,"Frequency","3 years"]
[null,null,"By whom","Intervention Implementer"]
[null,"Project Value",8]
[null,"QA/QC procedures"]
[null,null,"QC check done","Nama Implementer"]
[]
[null,"Serial number",{"$f":"+'Monitoring sheet'!A16","v":5}]
[null,"Indicator Name","Income generation/expenditure reduction/Balance of payments\n"]
[null,"Domain","Economic"]
[null,"Parameter Name","New income-generating activity (businesses) "]
[null,"Baseline Value",0]
[null,"Way of monitoring","How","HH survey / National census"]
[null,null,"Frequency","3 years"]
[null,null,"By whom","Intervention Implementer"]
[null,"Project Value",8]
[null,"QA/QC procedures"]
[null,null,"QC check done","Nama Implementer"]
[]
[null,"Serial number",{"$f":"+'Monitoring sheet'!A17","v":6}]
[null,"Indicator Name","Income generation/expenditure reduction/Balance of payments\n"]
[null,"Domain","Economic"]
[null,"Parameter Name","Number of new jobs (total) "]
[null,"Baseline Value",0]
[null,"Way of monitoring","How","HH survey / National census"]
[null,null,"Frequency","3 years"]
[null,null,"By whom","Intervention Implementer"]
[null,"Project Value",32]
[null,"QA/QC procedures"]
[null,null,"QC check done","Nama Implementer"]
[]
[null,"Serial number",{"$f":"+'Monitoring sheet'!A18","v":7}]
[null,"Indicator Name","Income generation/expenditure reduction/Balance of payments\n"]
[null,"Domain","Economic"]
[null,"Parameter Name","Number of new jobs for women"]
[null,"Baseline Value",0]
[null,"Way of monitoring","How","HH survey / National census"]
[null,null,"Frequency","3 years"]
[null,null,"By whom","Intervention Implementer"]
[null,"Project Value",16]
[null,"QA/QC procedures"]
[null,null,"QC check done","Nama Implementer"]
[]
[null,"Serial number",8]
[null,"Indicator Name","Policy and Planning"]
[null,"Domain","Economic"]
[null,"Parameter Name","NCA Organisation structure"]
[null,"Baseline Value",0]
[null,"Way of monitoring","How","Internal audit"]
[null,null,"Frequency","annually"]
[null,null,"By whom","NCA"]
[null,"Project Value",1]
[null,"QA/QC procedures"]
[null,null,"QC check done","Nama Implementer"]
[]
[null,"Serial number",9]
[null,"Indicator Name","Policy and Planning"]
[null,"Domain","Institutional"]
[null,"Parameter Name","Capacity development program"]
[null,"Baseline Value",0]
[null,"Way of monitoring","How","Audit"]
[null,null,"Frequency","annually"]
[null,null,"By whom","NCA"]
[null,"Project Value",1]
[null,"QA/QC procedures"]
[null,null,"QC check done","Nama Implementer"]
[]
[null,"Serial number",10]
[null,"Indicator Name","Policy and Planning"]
[null,"Domain","Institutional"]
[null,"Parameter Name","Promotion and awareness raising campaigns"]
[null,"Baseline Value",0]
[null,"Way of monitoring","How","Audit"]
[null,null,"Frequency","annually"]
[null,null,"By whom","NCA"]
[null,"Project Value",1]
[null,"QA/QC procedures"]
[null,null,"QC check done","Nama Implementer"]
[]
[null,"Serial number",11]
[null,"Indicator Name","Laws and regulations"]
[null,"Domain","Institutional"]
[null,"Parameter Name","Overall operation management system NCA"]
[null,"Baseline Value",0]
[null,"Way of monitoring","How","internal Audit"]
[null,null,"Frequency","annually"]
[null,null,"By whom","NCA"]
[null,"Project Value",1]
[null,"QA/QC procedures"]
[null,null,"QC check done","Nama Implementer"]
[]
[null,"Serial number",12]
[null,"Indicator Name","Laws and regulations"]
[null,"Domain","Institutional"]
[null,"Parameter Name","NIE Operation management system "]
[null,"Baseline Value",0]
[null,"Way of monitoring","How","Audit"]
[null,null,"Frequency","annually"]
[null,null,"By whom","NCA"]
[null,"Project Value",1]
[null,"QA/QC procedures"]
[null,null,"QC check done","Nama Implementer"]
[]
[null,"Serial number",13]
[null,"Indicator Name","Laws and regulations"]
[null,"Domain","Institutional"]
[null,"Parameter Name","NEE Operation management system "]
[null,"Baseline Value"]
[null,"Way of monitoring","How","Audit"]
[null,null,"Frequency","annually"]
[null,null,"By whom","NIE"]
[null,"Project Value",1]
[null,"QA/QC procedures"]
[null,null,"QC check done","Nama Implementer"]

{"sheet":"Monitoring sheet","index":7,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,1,0,17],[9,3,9,4],[9,5,9,10],[3,2,3,8]]}
[null,"Calculations & Monitoring"]
[]
[]
[null,"Intervention Name",{"$f":"Introduction!B53","v":"Mini grid "}]
[]
[]
[]
[]
[]
[null,"Parameter","Unit","Baseline",null,"Project"]
[null,null,null,"Value applied","Baseline value","Value applied","Year1","Value applied","Year4","Value applied","Year7"]
[1,"Number of public buildings electrified","building",0,0,3,3,5,5,8,8]
[{"$f":"A12+1","v":2},"Number of households electrified","household",0,{"$f":"D13*E7","v":0},2.5,300,5,500,5,1054]
[3,"People with access to RE electricity","person",0,0,1,1000,1,3000,1,6300]
[4,"Number of schools electrified","school",0,0,3,3,5,5,5,8]
[5,"New income-generating activity (businesses)","enterprises ",0,0,3,3,5,5,5,8]
[6,"Number of new jobs (total)","person",0,0,10,10,20,20,32,32]
[7,"Number of new jobs for women","women",0,0,5,5,10,10,16,16]
[8,"NCA Organisation structure","system",0,0,5,1,1,1,16,1]
[9,"Capacity development program","program",0,0,5,1,1,1,16,1]
[10,"Promotion and awareness raising campaigns","campaigns",0,0,5,1,1,1,16,1]
[11,"Overall operation management system NCA","system",0,0,5,1,1,1,16,1]
[12,"NIE Operation management system ","system",0,0,5,1,1,1,16,1]
[13,"NEE Operation management system ","system",0,0,5,1,1,1,16,1]

{"sheet":"Data Ranges (2)","index":8,"n_rows":44,"n_cols":13,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
["Effect on indicator","Number of parameters chosen","Effect","Air Quality",null,"Water Quality","Soil Quality","Other pollutants","Biodiversity and ecosystem balance","Climate change adaptation and mitigation",null,"sensitivity"]
["Positive","NA","+","SOx (Sulphur oxide)",null,"BOD","Levels of Lead","Reduction in noise levels","Number of threatened species/habitat","Resiliance - social",null,"exposure"]
["Negative",1,"-","NOx (nitrous oxide)",null,"COD","Mercury","Reduction in waste discharges","Addition of new gene pool","Resiliance - financial",null,"adaptive capacity"]
["Both",2,null,"Ozone",null,"Coliforms ","Cadmium","Increased visibility due to low SPM","Types of crops/species","Resiliance - human"]
[null,3,null,"Lead",null,"Improved wastewater management system","Soil erosion","Other (Please specify)","Other (Please specify)","Resiliance - natural"]
[null,"More than 3",null,"SPM (Suspended Particulate Matter)",null,"Water Savings","Indirect-wood consumption",null,null,"Resiliance - physical"]
[null,null,null,"CFC's",null,"New safe and reliable water ditribution","Production and use of compost",null,null,"Mitigation - Number of ER's accumulated"]
[null,null,null,"VOC (volatile organic compound)",null,"Purification/sterilization and cleaning of water","Manure nutrient",null,null,"Mitigation - change in technology deployed"]
[null,null,null,"Fly Ash",null,"Mercury","Other (Please specify)",null,null,"Vulnerability - social"]
[null,null,null,"Odour",null,"Lead",null,null,null,"Vulnerability - financial"]
[null,null,null,"Dust",null,"Other (Please specify)",null,null,null,"Vulnerability - natural"]
[null,null,null,"PM 10, 25",null,null,null,null,null,"Vulnerability - human"]
[null,null,null,"Number or share (%) of households burning waste",null,null,null,null,null,"Vulnerability - physical"]
[null,null,null,"Other (Please specify)",null,null,null,null,null,"Other (Please specify)"]
[]
[]
[]
[]
[]
["Health condition","Affordability of electricity","Livelihood of poor","Access to sanitation","Food security","Quality of employment","Time","Access to clean energy","Education","Empowerment of women","Access to sustainable technology","Energy security","Capacity building"]
["Decrease in disease prevelance","cost per unit of energy","% of people having access to modern energy and facility (including electricity, water, transport, modern resources etc)\n","% of people having access to clean drinking water and proper toilets\n","Number of people having proper nutrition value","number of employees with access to benefits","Time savings due to improved technolgies (biogas, ICS, efficient transport etc)"," Improvement of the access, availability and quality (coverage and reliability) \n","Number of people graduating per year","Number of women employed","Access to new transport system","imported fuels","Number and type of knowledge assets produced"]
["Decrease in accidents","share of household income spent on fuel and electricity","Number of people living below poverty line","Other (Please specify)","Decreased number of PEM cases","per capita or household income","Time availability due to projects","Share of people having access to sustainable electricity","Disemmination of information","Number of women in leadership positions","Innovation of new equipment and process","share of imported oil (attributed to sector)","Institutional Trainings "]
["Health detection and surveillance",null,"Re-settlement plan (in case of any displacement is required for project activity)",null,"Number of new crops grown","safe worker environment (proportion of laborers with access to safety equipment)","Other (Please specify)","Heating/cooling services","Research and increased awareness","Number of women receiving vocational training/education","Number of new technologies added","share of total energy supply from renewables","Private Sector Dialogue – or Dialogue across sectors and levels "]
["DALY's averted",null,"Other (Please specify)",null,"Export/import mapping","skill level (number of training sessions)",null,"Number of RE plants","Construction of school","Number of women in entrepreneurial roles","Access to waste management services",null,"Climate risk informed decision "]
["Life years gained",null,null,null,"Other (Please specify)",null,null,"Elelctricity consumption per capita","Number of children enrolling for primary education","Other (Please specify)","Number of training conducted",null,"Other (Please specify)"]
["Number of hospitals/health care facilities",null,null,null,null,null,null,"Other (Please specify)","Running of education programmes",null,"Other (Please specify)"]
["Reduction of health damaging air pollutants and indoor smoke",null,null,null,null,null,null,null,"Site visits and tours"]
["Avoided gas explosions or fire burns ",null,null,null,null,null,null,null,"Vocational trainings conducted"]
["Children immunized against deadly diseases",null,null,null,null,null,null,null,"Other (Please specify)"]
["Maternal mortality rate"]
["Other (Please specify)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Policy and planning:","Laws and regulation:"]
["Equality","Income generation","Asset","Job creation",null,"Measurement Unit",null,null,null,null,null,"Interministerial Dialogue ","Management, Coordination & Approvals ( NAMA Coordinating Authority) "]
["Number of people having access to jobs (women and men)","Fuel Savings per capita","Investment into new capacities","Per capita income",null,"Number","Direct",null,null,null,null,"Enabling Policy Environment","Implementation, Processes and Compliance with laws and efficient approvals (NAMA Implementer(s))"]
["Training sessions","Reduction in public expenditure by country","Establishment and maintenance of infrastructure","Number of jobs ( men and women; permanent Vs temporary)",null,"%","Indirect",null,null,null,null,null,"Implementation, Processes and Compliance with the SD tool"]
["Working conditions (good or bad)","Export Import Mapping","Enhancing productivity","Migration for jobs",null,"Specific unit"]
["Working hours for Men Vs Women","Reduction in use of foreign exchange","Reduction of production costs","Other (Please specify)",null,"Other (Please specify)"]
["No Child labour involved","Reduction in import of fossil fuels","Setting an example for other industries"]
["Other (Please specify)","Per capita income generation","Creation of business opportunities"]
[null,"Other (Please specify)","Other (Please specify)"]